FaStudentAid 
Logical Entity Name  FaStudentAid 
Default Table Name  FaStudentAid 
Physical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

FaStudentAid Columns 
ColumnName  Domain  Datatype  NULL  Definition 
FaStudentAidId(PK)(FK)    int  NO 
 
SyStudentID(FK)    int  NO 
 
AdEnrollID    int  NO 
 
SyAddressID    int  NO 
 
Source    char(1)  YES 
 
FaFundSourceID(FK)    int  YES 
 
AwardYear    char(7)  YES 
 
AmAgencyBranchID    int  YES 
 
FaBankID(FK)    int  YES 
 
FaServicerID    int  YES 
 
FaGuarantorID    int  YES 
 
AmountPackaged    money  NO 
 
BankFee    money  NO 
 
AmountDisbursed    money  NO 
 
AmountCanceled    money  NO 
 
AmountRefunded    money  NO 
 
DateLoanStart    datetime  YES 
 
DateLoanEnd    datetime  YES 
 
DateAppSent    datetime  YES 
 
DateAppReceived    datetime  YES 
 
FaStudentAYID(FK)    int  YES 
 
FirstPayDate    datetime  YES 
 
LastInterestDate    datetime  YES 
 
PaymentDay    tinyint  YES 
 
PaymentFreq    smallint  YES 
 
InterestRate    numeric(5, 2)  YES 
 
NumberPayments    smallint  YES 
 
TotalPaid    money  YES 
 
PrincipalBalance    money  YES 
 
InterestBalance    money  YES 
 
NextPayDate    datetime  YES 
 
PaymentAmount    money  YES 
 
Status    char(1)  YES 
 
Comment    text  YES 
 
UserID    int  NO 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
ts    timestamp  NO 
 
FaStudentPellID    int  YES 
 
BankFeeToCOA    bit  NO 
 
InterestRebateAmt    numeric(18, 0)  YES 
 
ServicerRecordID    char(20)  YES 
 
AddUserID    int  NO 
 
FaBatchPackageID(FK)    int  YES 
 
EstimatedAward    bit  NO 
 
SecondaryInterestRate    numeric(6, 3)  YES 
 
SecondaryInterestRateEffDate    datetime  YES 
 
IntOnlyUntilDate    datetime  YES 
 
AccruedInterestAmt    money  NO 
 
IsAutoDraft    bit  NO 
 
EffectiveDate    datetime  YES 
 
SaStudentBankAccountID(FK)    int  YES 
 
SaCcId(FK)    int  YES 
 
IsAutoCredit    bit  NO 
 
CcEffectiveDate    datetime  YES 
 
T4BalanceEvaluated    bit  NO 
 
LastStatementPrintDate    datetime  YES 
 
LastPNPrintDate    datetime  YES 
 
FaCODGrantID(FK)    int  YES 
 
UserLocked    bit  NO 
 
LockedByUserId    int  YES 
 
DownPayment    money  YES 
 
PromNoteCmDocumentId    int  YES 
 
CalculationDate    datetime  YES 
 
LoanIdentificationNumber    int  YES 
 
IsReAllocated    bit  NO 
 
Rep9010DiscountRate    numeric(5, 2)  YES 
 
Rep9010CollectionRate    numeric(5, 2)  YES 
 
Rep9010NumOfYears    smallmoney  YES 
 
FaStudentLoanPeriodID    int  YES 
 
LoanAcYrStartDate    datetime  YES 
 
LoanAcYrEndDate    datetime  YES 
 
IsAXLinkedFWS    bit  NO 
 

FaStudentAid Primary and Unique Keys 
Key Name  Key Type  Keys 
FaStudentAid_FaCODGrantID_FaStudentAidID_U_N_IDX  Index  FaCODGrantID, FaStudentAidId 
FaStudentAid_SyStudentID_AwardYear_FaFundSourceID_FaStudentAidID_U_N_IDX  Index  SyStudentID, AwardYear, FaFundSourceID, FaStudentAidId 
FaStudentAid_AwardYear_FaStudentAidID_U_N_IDX  Index  AwardYear, FaStudentAidId 
FaStudentAid_FaStudentAidID_U_C_IDX  PrimaryKey  FaStudentAidId 
Uk_FaStudentAid_FaFundSourceID_AwardYear_Status_AdEnrollID_FaStudentPellID_SyStudentID_FaStudentAidID  Index  FaFundSourceID, AwardYear, Status, AdEnrollID, FaStudentPellID, SyStudentID, FaStudentAidId 

FaStudentAid Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
FaLender  Non-Identifying  Zero or One to Zero or More  FK_FaStudentAid_FaBankID_FaLender_FaLenderID      FaBankID  NO  YES 
FaBatchPackage  Non-Identifying  Zero or One to Zero or More  FK_FaStudentAid_FaBatchPackageID_FaBatchPackage_FaBatchPackageID      FaBatchPackageID  NO  YES 
FaCODGrant  Non-Identifying  Zero or One to Zero or More  FK_FaStudentAid_FaCODGrantID_FaCODGrant_FaCODGrantID      FaCODGrantID  NO  YES 
FaFundSource  Non-Identifying  Zero or One to Zero or More  FK_FaStudentAid_FaFundSourceID_FaFundSource_faFundSourceID      FaFundSourceID  NO  YES 
FaStudentPell  Identifying  One To Zero or More  FK_FaStudentAid_FaStudentAidID_FaStudentPell_FaStudentPellID      FaStudentAidId  NO  YES 
FaStudentAY  Non-Identifying  Zero or One to Zero or More  FK_FaStudentAid_FaStudentAYID_FaStudentAY_FAStudentAYID      FaStudentAYID  NO  YES 
SaCC  Non-Identifying  Zero or One to Zero or More  FK_FaStudentAid_SaCcId_SaCc_SaCcId      SaCcId  NO  YES 
SaStudentBankAccount  Non-Identifying  Zero or One to Zero or More  FK_FaStudentAid_SaStudentBankAccountID_SaStudentBankAccount_SaStudentBankAccountID      SaStudentBankAccountID  NO  YES 
syStudent  Non-Identifying  One To Zero or More  FK_FaStudentAid_SyStudentID_syStudent_SyStudentID      SyStudentID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
FaCampusVantageWorkStudyPayroll  Non-Identifying  One To Zero or More  FK_FaCampusVantageWorkStudyPayroll_FaStudentAidID_FaStudentAid_FaStudentAidId        NO  YES 
FaCashPlanWorkflowAudit  Non-Identifying  One To Zero or More  FK_FaCashPlanWorkflowAuditFaStudentAidId_FaStudentAidFaStudentAidId        NO  YES 
FaCODGrantDisb  Non-Identifying  One To Zero or More  FK_FaCODGrantDisb_FaCODGrantID_FaStudentAid_FaStudentAidID        NO  YES 
FaDisb  Non-Identifying  One To Zero or More  FK_FaDisb_FaStudentAidID_FaStudentAid_FaStudentAidID        NO  YES 
FaLoan  Non-Identifying  One To Zero or More  FK_FaLoan_fastudentaidid_FaStudentAid_FaStudentAidID        NO  YES 
FaLoanCommonLineChangeSendLog  Non-Identifying  One To Zero or More  FK_FaLoanCLChangeSendLog_FaStudentAidId_FaStudentAid_FaStudentAidId        NO  YES 
FaPromNotePrintAssignment  Non-Identifying  One To Zero or More  FK_FaPromNotePrintAssignmentFaStudentAidId_FaStudentAidFaStudentAidId        NO  YES 
FaRefund  Non-Identifying  One To Zero or More  FK_FaRefund_FaStudentAidID_FaStudentAid_FaStudentAidID        NO  YES 
FaStudentAidCalculation  Non-Identifying  One To Zero or More  FK_FaStudentAidCalculationFaStudentAidID_FaStudentAidFaStudentAidID        NO  YES 
FaStudentAidCashPlanAssignment  Non-Identifying  One To Zero or More  FK_FaStudentAidCashPlanAssignment_CashFaStudentAidId_FaStudentAid_FaStudentAidId        NO  YES 
FaStudentAidCashPlanHistory  Non-Identifying  One To Zero or More  FK_FaStudentAidCashPlanHistory_FaStudentAid_FaStudentAidId        NO  YES 
FaStudentAidCalculation  Non-Identifying  One To Zero or More  FK_FaStudentAidID        NO  YES 
FaStudentAYPaymentPeriod  Non-Identifying  One To Zero or More  FK_FaStudentAYPaymentPeriod_FaStudentAidId_FaStudentAid_FaStudentAidId        NO  YES 
FaStudentLPPaymentPeriod  Non-Identifying  One To Zero or More  FK_FaStudentLPPaymentPeriod_FAStudentAid_FAStudentAidID        NO  YES 
SaCollections  Non-Identifying  One To Zero or More  FK_SaCollections_FaStudentAidID_FaStudentAid_FaStudentAidID        NO  YES 
SaStatementHistory  Non-Identifying  One To Zero or More  FK_SaStatementHistory_FaStudentAidID_FaStudentAid_FaStudentAidID        NO  YES 
SyAudit_FaStudentAid  Non-Identifying  One To Zero or More  FK_SyAudit_FaStudentAid_RecordID_FaStudentAid_FaStudentAidID        NO  YES 
SyServiceMessageSourceRecord  Non-Identifying  One To Zero or More  FK_SyServiceMessageSourceRecordFaStudentAidId_FaStudentAidFaStudentAidId        NO  YES 

FaStudentAid Check Constraints 
Check Constraint Name  CheckConstraint 
Chk_FaStudentAid_IntOnlyUntilDate  ([IntOnlyUntilDate] is null and [FirstPayDate] is null or [IntOnlyUntilDate] is null and [FirstPayDate] is not null or [IntOnlyUntilDate] is not null and [FirstPayDate] is not null and [IntOnlyUntilDate] > [FirstPayDate]) 
Chk_FaStudentAid_SecondaryInterestRateEffDate  ([SecondaryInterestRateEffDate] is null and [FirstPayDate] is null or [SecondaryInterestRateEffDate] is null and [FirstPayDate] is not null or [SecondaryInterestRateEffDate] is not null and [FirstPayDate] is not null and [SecondaryInterestRateEffDate] > [FirstPayDate]) 

FaStudentAid Storage 
STORAGE OPTION  STORAGE VALUE 
Filegroup  PRIMARY 
Text Image File Group  PRIMARY 

FaStudentAid Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.StudentAward 
NO       
Physical (Microsoft SQL Server)
dbo.FaStudentAid 
NO       

FaStudentAid Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  LedgerCard_Billing 
Logical  RefundCalculation 
Logical  Refunds_Stipends 
Logical  StudentPayments_Collections 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Financial Aid 

FaStudentAid Data Movement Rules 
Name  Type  Rule Text/Value